ABSTRACT
With the onset and increase in the number of online courses and blended mode of delivery owing to the Covid-19 pandemic, there has been a need for an accurate and consolidated online attendance registers that can easily be queried at Botswana Accountancy College. As the attendees switch access devices or when the experience connectivity issues during a remotely conducted class, multiple entries of the same attendee are logged to the Microsoft Teams attendance registers. Additionally, the format of the downloaded attendance registers is different from the current attendance management systems, making attendance accounting a cumbersome task. A data wrangling model therefore will assist in the restructuring of the downloaded registers by eliminating duplicates, reshaping the same for ease of querying and consolidation. The success of the wrangling model will simplify attendance reporting, free-up the lecturers of the manual task of attendance accounting and coincidentally eliminating the human error element.